﻿CREATE PROCEDURE [dbo].[sp_public_changePassword]
	@Email nvarchar(100), 
	@Password nchar(32),
	@Code nchar(10)
AS
	UPDATE Members SET Member_Pass = @Password, Member_Code = @Code
	WHERE Member_Email = @Email
RETURN 0